UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fmnjYIKE6OZeNGHhuQG+rajZ1FYRJSnGy78bwK6j2i8='
WHERE
key_id = '417609fd3f5b8492f9b1f5ac475acca8c1e02b8bb9749a15752908e72f866afa'
AND (
token = 'fmnjYIKE6OZeNGHhuQG+rajZ1FYRJSnGy78bwK6j2i8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)