UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6gFxRfsD9R9NXiqgdIHKwdZTvUkfvZkN58VjB8CHbqA='
WHERE
key_id = '99f8653bad3891459f203a1ffd391644d32c94bc957b0fdd6284e40d74a2d6fb'
AND (
token = '6gFxRfsD9R9NXiqgdIHKwdZTvUkfvZkN58VjB8CHbqA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)