UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BW1fJVh1J+OQ7sOOYwEa/30ITjPi57+Za3SmdZ0LlRA='
WHERE
key_id = '03d3c1bfc4d6e91dca70392c6dc0a7ae49fa763b55775f3b576c560fe28ba331'
AND (
token = 'BW1fJVh1J+OQ7sOOYwEa/30ITjPi57+Za3SmdZ0LlRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)