UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QqBZ9YSarZFZRtZ8xc8zQX/DB/oKdSbXCglUstfGE9I='
WHERE
key_id = '8f1810841dad00d24194c43817c558fe0e87c32e3f25ef34a981e5b5f734ba2f'
AND (
token = 'QqBZ9YSarZFZRtZ8xc8zQX/DB/oKdSbXCglUstfGE9I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)