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