UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7l2gfbfruqHY6NmsIwVp3bYrOtmpcirEFu+DJ3qItOE='
WHERE
key_id = 'a947e4266b55cce7bd5c9b0b5e7d8ab5adff090b592390bf9b52484f3da9243a'
AND (
token = '7l2gfbfruqHY6NmsIwVp3bYrOtmpcirEFu+DJ3qItOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)