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