UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r8xFUgePUyGwpYsTAqAmkirXQyGMvZsJNATDbbOBwnw='
WHERE
key_id = 'd909e2706473bb33d993b874203805d7e5ed5c235a681c8cf3409bf71b290149'
AND (
token = 'r8xFUgePUyGwpYsTAqAmkirXQyGMvZsJNATDbbOBwnw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)