UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nEsnOmM7cRatD5Lhzf2fuZjLK0puRSiuja/YazmIL/I='
WHERE
key_id = '2d6a522deb38520c31b6e39ff1027c823a490945d5365ab290faf2f18c2f9e95'
AND (
token = 'nEsnOmM7cRatD5Lhzf2fuZjLK0puRSiuja/YazmIL/I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)