UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KPTaOn9R9ayg4+b7e7QGI2Cb3JbFYGYXaidh6OWyXgE='
WHERE
key_id = '661def46318754d418a289c54b7776aa6387b64c6ddfbe2f67649852e107fe94'
AND (
token = 'KPTaOn9R9ayg4+b7e7QGI2Cb3JbFYGYXaidh6OWyXgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)