UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SYsouZijxL9HlieqovyF/IOTMgJrY6BCuWzkhsFsGco='
WHERE
key_id = '9bd3089f250190d68e136051951735ded794591ac4820f5b1ebc0bff18f86116'
AND (
token = 'SYsouZijxL9HlieqovyF/IOTMgJrY6BCuWzkhsFsGco='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)