UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hb3UJDgs9VqchYG1I9319YxYPvCXf0Nc3R7xFolhYH4='
WHERE
key_id = '4dc4222331e5da1f4d683e9d8346e6c4dfc85cb5fd548f77decaea752ef4c9a9'
AND (
token = 'Hb3UJDgs9VqchYG1I9319YxYPvCXf0Nc3R7xFolhYH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)