UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5B5yRUE4J2PSr7JA8QZwQTncpfx1m7xu7CNiJoSiOWw='
WHERE
key_id = '31aaa67a7ecda5b44ad2675f81c48b2ef8a826f33de3f95441a205b3da6bffd7'
AND (
token = '5B5yRUE4J2PSr7JA8QZwQTncpfx1m7xu7CNiJoSiOWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)