UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hefRb95Rt4wVrVa7bSjBBt3BAsu+2TWUX18DKakphSQ='
WHERE
key_id = 'd2ad057ef16707017967ec3aaab3e6f44cca879103a662361ae1ba06ac3e94fb'
AND (
token = 'hefRb95Rt4wVrVa7bSjBBt3BAsu+2TWUX18DKakphSQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)