UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H8GTDbuIj6mP3DTy9z2FdvICSbphbYVsStr2icqulxo='
WHERE
key_id = '24d362708b1c56e73b55e1e6007542aafbcb556d145d8218c42145ab7332af6a'
AND (
token = 'H8GTDbuIj6mP3DTy9z2FdvICSbphbYVsStr2icqulxo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)