UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2LmroHf3+VHVmNTUQamThBtlxI7e2hJgr4r3e7OmYos='
WHERE
key_id = '6e64806e5521294b2cb34cc3c5ae0f4c343297bc45c3bf1f680388af350d5c23'
AND (
token = '2LmroHf3+VHVmNTUQamThBtlxI7e2hJgr4r3e7OmYos='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)