UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qjXKI7Sw24OfZDoi3L5xraI+G80lagGYyPsm1nH/+b4='
WHERE
key_id = '78515851b824a488f81e455c565738680831590b056306a29e7d22c140513bd1'
AND (
token = 'qjXKI7Sw24OfZDoi3L5xraI+G80lagGYyPsm1nH/+b4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)