UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kmstAsxBLGvz8wPbb2RGiYlrq8W408xD5LvlRa8HgUo='
WHERE
key_id = 'c562963455317d8206cbecb147caa1d0ff6c1d4ce4a50a0595810922f25d5a9b'
AND (
token = 'kmstAsxBLGvz8wPbb2RGiYlrq8W408xD5LvlRa8HgUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)