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