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