UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '39t1DGOJR4tRUWmiYNAm4+4KZD57J3pwSFAR6del4Qk='
WHERE
key_id = '247eca55e8847df68e84831d67e1a9b0a0ce37de053d1d154c9ee5b316561659'
AND (
token = '39t1DGOJR4tRUWmiYNAm4+4KZD57J3pwSFAR6del4Qk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)