UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Dz+3wJwvkk6bu9yvAOLZDHLiMHYHiKJAA5AoZnZzBi8='
WHERE
key_id = 'dbc0fd842f70175cd8994552a466c375cb50b3dc4a3ddaaeaa8263307464efcc'
AND (
token = 'Dz+3wJwvkk6bu9yvAOLZDHLiMHYHiKJAA5AoZnZzBi8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)