UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tBs4a/an4qpfyLHU0t03nu5u8bnDsul3A70AiA/P63U='
WHERE
key_id = 'a417d8a51055e74eac956e9ee450c93096995f5596b9b28f4058028bb00d7e7d'
AND (
token = 'tBs4a/an4qpfyLHU0t03nu5u8bnDsul3A70AiA/P63U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)