UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+aM23m4/Q9QnxsuCKgTW5U9zoBpnWPgtn+VzHCXI+0g='
WHERE
key_id = 'f29e814f4f6c0ad99183f9961b942cc39cf4211c1aa5b0e8f4d959a0ec8114c9'
AND (
token = '+aM23m4/Q9QnxsuCKgTW5U9zoBpnWPgtn+VzHCXI+0g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)