UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nwfA5coFcGS7j2JgNZGhfFCBjBvPZcwj28NxyJdCYCw='
WHERE
key_id = '59b2193fb63a13fca5fe520c947e76186c3ed89140072f109e30ce296ad45adb'
AND (
token = 'nwfA5coFcGS7j2JgNZGhfFCBjBvPZcwj28NxyJdCYCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)