UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3j1VOh+9kJajbdrYvOu2R9agapXX4IeIgOk22++NcGE='
WHERE
key_id = '8d8f06f34c03aa3bd4589291f0acd6a871f5be574efa414974cf53ab97f84193'
AND (
token = '3j1VOh+9kJajbdrYvOu2R9agapXX4IeIgOk22++NcGE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)