UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A1zI/5+Wt+/ZCDZbOYw/fRRDiTYetGOut9TXr4tAykU='
WHERE
key_id = '06a4ae3d0011e542e73ea2abf319caca425a7a191abae6375892b4ed559868fe'
AND (
token = 'A1zI/5+Wt+/ZCDZbOYw/fRRDiTYetGOut9TXr4tAykU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)