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