UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hpbNkmfDtu9C1H+c8H+RnceotU3kxdvBFiRLv5Jc/cI='
WHERE
key_id = '9ba2a7e4a7ed98971ab791e721f761c6ecdd7ee6b7239eac3716ac6a455deae1'
AND (
token = 'hpbNkmfDtu9C1H+c8H+RnceotU3kxdvBFiRLv5Jc/cI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)