UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VBXHUxPRt0SD+QxtDJ3gF1R6EX9wKXGKdfkPm1Ltdhw='
WHERE
key_id = '1c31f7e48e8c92a5c02ed004a170826dda46d5809c3ebdc096cf285629ece395'
AND (
token = 'VBXHUxPRt0SD+QxtDJ3gF1R6EX9wKXGKdfkPm1Ltdhw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)