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