UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8We6GJFfdjC+b2VQCbTPQo1yo2HtzlTGNBbrAFmkUyc='
WHERE
key_id = '67de77c4afd1c8fd189d455d404263cc68a6ff8a712add14b891066345399352'
AND (
token = '8We6GJFfdjC+b2VQCbTPQo1yo2HtzlTGNBbrAFmkUyc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)